<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreatePersonalAuthTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        //个人认证
        Schema::create('personal_auth',function(Blueprint $table)
        {
            $table->increments('id');
            $table->integer('user_id')->default(0)->comment('用户id');
            $table->string('realname')->nullable()->comment('真实姓名');
            $table->integer('sex')->default(0)->comment('性别 0：保密 1：男 2：女');
            $table->string('unit_name')->nullable()->comment('单位名称');
            $table->string('job')->nullable()->comment('岗位');
            $table->string('id_card')->nullable()->comment('身份证号');
            $table->integer('work_img_id')->default(0)->comment('在职证明');
            $table->integer('is_auth')->default(0)->comment('认证情况 0：未认证 1：通过 2：拒绝 3：注销认证');
            $table->softDeletes();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
